Show All

Copy data validation settings

1. Click the cell with the settings you want to copy, and click Copy .
2. Select the cells for which you want to duplicate the settings.
3. On the Edit menu, click Paste Special.
4. Click Validation.

Note  You cannot copy or paste data validation within cells of a list that is linked to a SharePoint site.

Tip